Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | ExternalDepositoryDocument(LE_HST_EXTDST) |
TenderRepositoryID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | ExternalDepositoryDocument(LE_HST_EXTDST) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. | TY_TND | Code | varchar(20) | Tender(AS_TND) |
OpenBalanceTotalAmount | The monetary amount of the opening balance of TENDER in the EXTERNAL DEPOSITORY at the start of the external depository settlement period. | MO_BLNC_OPN | Money | decimal(16,5) | |
DepositTotalAmount | The total amount of tender deposited in the EXTERNAL DEPOSITORY for each external depository settlement period. | MO_DS_TND | Money | decimal(16,5) | |
TotalTenderDepositCount | The total number of TENDER deposits made in the EXTERNAL DEPOSITORY for each external depository settlement period. | QU_DS_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
DepositDateTimestamp | The timestamp when tender is deposited in the EXTERNAL DEPOSITORY for each external depository settlement period. | TS_DS_TND | AuditDateTime | datetime | |
ReceiptTotalAmount | The total amount of money received from the EXTERNAL DEPOSITORY in each external depository settlement period. | MO_RCV_TND_TOT | Money | decimal(16,5) | |
TotalTenderReceiptCount | The total number of receipts to the STORE from the EXTERNAL DEPOSITORY in each external depository settlement period. | QU_RCV_TND_TOT | QuantityTransactionCount | decimal(7,0) | |
UnderTenderDiscrepancyAmount | The shortage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY for external depository settlement period. | MO_DSCP_TND_UND | Money | decimal(16,5) | |
OverTenderDiscrepancyAmount | The overage, expressed as an amount, between the actual and recorded tender deposited in the EXTERNAL DEPOSITORY for external depository settlement period. | MO_DSCP_TND_OVR | Money | decimal(16,5) | |
TotalTenderCountedAmount | The actual tender monetary value counted as part of the settlement process. | MO_TOT_TND__CNT_AMT | Money | decimal(16,5) | |